In your SQL statement have you considered using the BETWEEN comparision?

SELECT * FROM calendar WHERE now() BETWEEN starttime AND endtime;
[download]

I am not sure that this is the correct syntax, but it should give an idea of how to accomplish what you are asking.