UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Dcp7RzmQDuRuOlXx8uyL1Zsk4fJYYOIBimOx940lNNQ='
WHERE
key_id = '9059785ffcb4ff08378d542712ff6a15eac4526cfbebf62ae6f179af5dd52692'
AND (
token = 'Dcp7RzmQDuRuOlXx8uyL1Zsk4fJYYOIBimOx940lNNQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)