Create a temp table, insert the problem child_id's into it, then do the update based on the temp table. Drop the temp table.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.