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