UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JxWLpwilzbLrsD7izDTFn/iq78Qgli1lK0bW37iFnCU='
WHERE
key_id = '48771b4d8fc9f44855b77ea43622aa7702ddad17222990fd8588a9142987fa0a'
AND (
token = 'JxWLpwilzbLrsD7izDTFn/iq78Qgli1lK0bW37iFnCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)