UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dT1itEnAN7NFsGGazPd6LAM5jWpovFgioggwtvA4EKs='
WHERE
key_id = 'a873f0cc2baf8ca40c40411a17124e54b3974fe3bfba72465dfee4569b86f310'
AND (
token = 'dT1itEnAN7NFsGGazPd6LAM5jWpovFgioggwtvA4EKs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)