UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oVVAEzJ3hgyBGKTV6v/akk9WcNEDoDDL/5jJZRRVge0='
WHERE
key_id = 'b81487f57071cc5b4312b0d17a3b0b56d2bc03f08205bebd7446d373bd0a497f'
AND (
token = 'oVVAEzJ3hgyBGKTV6v/akk9WcNEDoDDL/5jJZRRVge0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)