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