UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YCt0WACBhuOZ69gAY7QCLd7fVh34HLrfm4Q6tvTi730='
WHERE
key_id = '7d0f24fd610cf3bb4fb0ba150c5c0f7a83de2e8acf361aa7df556fe1c3cc3008'
AND (
token = 'YCt0WACBhuOZ69gAY7QCLd7fVh34HLrfm4Q6tvTi730='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)