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.
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information