Something

UPDATE restaurant SET is_current_status_print = 1 WHERE restaurant_id IN (
SELECT restaurant_id FROM schedule JOIN hours ON schedule.hours_id = hours.hours_id WHERE weekday = (DATEPART(dw, GETDATE())-1) AND DATEPART(hh, GETDATE()) - DATEPART(hh, first_pickup) = -1)