UPDATE clowns SET deleted=1 WHERE id IN
(SELECT id FROM (
  SELECT id FROM clowns WHERE deleted = 0 ORDER BY id ASC LIMIT 0, 800)
tmp );