Q:

How to select records with minutes interval range of current day and time? 

I have columns:
date = "2017-12-10" (type = date)
time = "14:10:00" (type = time)
duration = "40" (type = varchar 100)
For example, today date is "2017-12-10" and today time is "14:30".  How can I get records only for current time and only in time interval "40 minutes"?  So accepted time range would be "14:10:00-14:50:00". 
I've tried something like this:
SELECT date, time, duration FROM events WHERE date = CURDATE() AND time >= CURTIME();

But it doesn't search in 40 minutes interval. 
Thank you. 

A:

this?  
SELECT date, time, duration FROM events WHERE date = CURDATE() AND time between date_add(CURTIME(), interval -duration minutes) and CURTIME();

