UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bOh2ofggjch6hy5FLWxheDMxrwMgkGVoQ3hBMEh/HeM='
WHERE
key_id = 'acf07548571aa71abe9f48d407f783801f813c3a034ce12612c30dde39578c65'
AND (
token = 'bOh2ofggjch6hy5FLWxheDMxrwMgkGVoQ3hBMEh/HeM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)