UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qVae++9IQh57AU+wNYr9nfX+UO4RH7xUqK07BLt4cvE='
WHERE
key_id = '4701b7e8857fc6f67ed1e83b3d2cb07b476e0d24717d22c548ff835974ff7941'
AND (
token = 'qVae++9IQh57AU+wNYr9nfX+UO4RH7xUqK07BLt4cvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)