Update queries to use now() instead of %S as it includes local timezone