UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SmKOHbsZuwPRGHX3nMIvL+xq7Jt14kc5fcXwky4CjXs='
WHERE
key_id = 'b0c1e127f30834797eae4c450397894caeb5bd2cf3eadcf6779ce71f1a08df6a'
AND (
token = 'SmKOHbsZuwPRGHX3nMIvL+xq7Jt14kc5fcXwky4CjXs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)