UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0dGuyzbSGPDbzSV59RBzwzfEkrI0JBqXVlAInhv92yw='
WHERE
key_id = '9065d2e7ee6404578d825bba204d32ea85652e965e313d244f1bc1ce21232f0d'
AND (
token = '0dGuyzbSGPDbzSV59RBzwzfEkrI0JBqXVlAInhv92yw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)