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