UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4FXNvQMfgyjeDFG/0kAwzmjMzRRWr9Gb6EBWu5kb8B4='
WHERE
key_id = '9819edb6dc658b78cd867f55b6e78ff7ea056787d5b28a27c03a4cd26ad4f7d8'
AND (
token = '4FXNvQMfgyjeDFG/0kAwzmjMzRRWr9Gb6EBWu5kb8B4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)