UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pP6ezjc/MY1Q1I3syn13nYRe6f2h1hrLCHZR+uas8uU='
WHERE
key_id = 'bbaad8ee2b860b13b8c4d2413f9f9951ed76b7cbfc5b7fd9b8bc8499ac9a0475'
AND (
token = 'pP6ezjc/MY1Q1I3syn13nYRe6f2h1hrLCHZR+uas8uU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)