Actually spent some time last night figuring this out. We always query the CACHE table every time the cfrm page is loaded. We do this to find out if the max_online count is ever exceeded. I'll just add a new entry into this table that we can grab at the same time. This will just be a timestamp that birthday notices were sent out. So we can check and see if they need to be sent again. No extra query involved.