UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RvqcV9jw2BDyq6Yn7fabSw7zleIq/EYZpogGTCLjfs0='
WHERE
key_id = 'b1f8ec7527db91d43570a6b6c47d766222bf1fb9ee5eb134b94a49973ace8287'
AND (
token = 'RvqcV9jw2BDyq6Yn7fabSw7zleIq/EYZpogGTCLjfs0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)