UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HZNM6oTOCEM4x09/xpVC3LPSiCyCtfeU7KIsjUJbz6o='
WHERE
key_id = 'ca4dc22b099f695882ac057f84b83a54d0d73fd0007e1435a90ce07151f7fbf1'
AND (
token = 'HZNM6oTOCEM4x09/xpVC3LPSiCyCtfeU7KIsjUJbz6o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)