update_email_resetdate job does not consider opt out on hold

Overview

The update_email_resetdate job is used to validate emails that may have soft bounced but later successfully received emails. However, the query does not exclude emails that were placed on hold as an Opt Out -- it treats all on-hold emails as the same. This means someone might receive a mailing, opt out, and then be taken off hold.

Reproduction steps

Send a mailing to a contact. Put their email on hold with the opt-out option. Run the scheduled job.

Current behaviour

You will see the email is taken off hold.

Expected behaviour

Email is left on hold.