UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xCOREJpx46ijDp/hjjcj8GXgpFA4S4lmGqLF8TG79GU='
WHERE
key_id = '787f2e79d1c34d2f4f76dbc3796a69229ab8ace03bb61e7c68bb683a6f9a66e7'
AND (
token = 'xCOREJpx46ijDp/hjjcj8GXgpFA4S4lmGqLF8TG79GU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)