Use a temporary table to do a delete or other command on results from a command.

CREATE TEMPORARY TABLE temp
SELECT client_ip FROM `cdn_logs` GROUP BY client_ip
HAVING COUNT(*) > 10;

DELETE FROM cdn_logs WHERE client_ip IN (SELECT client_ip FROM temp);

DROP TEMPORARY TABLE temp;