UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XxQ1KdKWtPZvYarNT2abwIbOwcRXV0cdUIRhsnCpUgo='
WHERE
key_id = '89228e856a6f7f97966508a22ff08d0389016ae402b0c32b142d149651126ec7'
AND (
token = 'XxQ1KdKWtPZvYarNT2abwIbOwcRXV0cdUIRhsnCpUgo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)