UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ao1rlUW5k8o64yKg2QBJEtQ9dWUhQEwwM4wwWK9UYg8='
WHERE
key_id = '8462753e8a5d91de9e0ab406cb0731cc172cf56a3318e6825b5d53902aa82cc9'
AND (
token = 'Ao1rlUW5k8o64yKg2QBJEtQ9dWUhQEwwM4wwWK9UYg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)