UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lvKZzM2ms1C/AbgOtiFrJjZMGHQEZRUV5hBBaD6aVWE='
WHERE
key_id = '94ab1c83afed861273263817df54d9702607e89464d048d652100b07f65b299a'
AND (
token = 'lvKZzM2ms1C/AbgOtiFrJjZMGHQEZRUV5hBBaD6aVWE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)