Finding five-minute interval prior to current time
Try this query

    select date_add(now(), interval -5 minute) five_mins_interval,
    date_add(now(), interval -10 minute) ten_mins_interval, now() 
    currentTime