UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vk78gPUOlyZj/QZIUkr7RVPwjq1IRpiDOWdC9w8Escc='
WHERE
key_id = '8e254a6b6f9ca7f864dca20cae4574bc920bf2564de345e7fce7138dd6c324d5'
AND (
token = 'vk78gPUOlyZj/QZIUkr7RVPwjq1IRpiDOWdC9w8Escc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)