UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8pnQ3s0HCZMDt8N9+bwhrFXDbojtUoK9waA1J1g093g='
WHERE
key_id = '853c28545c59d4007328e4d5f4f0ff6a65696ed421c253814d7ea95ea518a165'
AND (
token = '8pnQ3s0HCZMDt8N9+bwhrFXDbojtUoK9waA1J1g093g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)