Update MySQL user table of active/inactive members based on array
Don't use EXISTS or IN ( SELECT ... ).

Use a multi-table UPDATE.  Twice.

Once with a JOIN to set the active rows.
Once with a LEFT JOIN ... IS NULL to set the inactive rows.

Or...

Once to set all users to inactive.
Once with a JOIN to set the active rows.