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