UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QsX1lO1kIUt9PFufMwkn5rWNbv8QqBjZxUR6ewtwZfU='
WHERE
key_id = '140f4212d8c00b8c2cb8154436ec302cc267f2719f6cb0553765160e26bce4cc'
AND (
token = 'QsX1lO1kIUt9PFufMwkn5rWNbv8QqBjZxUR6ewtwZfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)