When I try to update/set a datetime I get an invalid mysql syntax 1064
9.1.3 Date and Time Literals

Enclosing that datetime string in single quotes, 'YYYY-MM-DD HH:MM:SS' should work:

UPDATE xxxxx_eb_events 
Set event_date = '2019-04-01 00:00:00';