The title might be a bit non-specific but I couldn't think of any better way to describe the issue.
I don't know if the following is even possible in SQL so if not I would love to hear it as well including what you would use as a solution.
I have a table that had a column that stores a date and a column that stores a time. If both have passed I need to set a third columns value to true and send an email to a stored email address.
It is not possible to change the database structure.
I have been searching quite some time now and still have no idea on where to start solving this.