Select query will be locked because you have transaction still open when it is executed by email.

I second Lowell idea of job or maybe you could use service broker when email conditions are met. We had to use service broker in our database for OLTP database in trigger because of perf problems.