Trigger - If time between?
You need something like that:

BEGIN
  IF CURTIME() BETWEEN '08:00:00' AND '11:59:59'
    THEN UPDATE ...
  END IF
END


This trigger will be activated each time the event occure but it will do something only if current time is within the given range and will do nothing otherwise.