UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I8KirF4ewb2vSUuUAB46/8ZoN/p4/zgBL1ITEswyTA8='
WHERE
key_id = '7e72b09432f91b87da31230332891c82a0184f4c10c768d031c4ae49539df47d'
AND (
token = 'I8KirF4ewb2vSUuUAB46/8ZoN/p4/zgBL1ITEswyTA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)