UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qgPCG4o1pniJ8nOqKeZL185He576181lQOgOKKAfGQU='
WHERE
key_id = 'ca71a07a50e940c03af2e2038903afff8a31794d602dfdb26742ea1edd47c50a'
AND (
token = 'qgPCG4o1pniJ8nOqKeZL185He576181lQOgOKKAfGQU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)