MySQL - Query records between yesterday and today but with a specific time
USE CURDATE() and INTERVAL
SELECT CURDATE() - INTERVAL 1 DAY + INTERVAL 8 HOUR, CURDATE() + INTERVAL 8 HOUR

RESULT
# CURDATE() - INTERVAL 1 DAY + INTERVAL 8 HOUR  CURDATE() + INTERVAL 8 HOUR
2020-11-19 08:00:00                             2020-11-20 08:00:00