How to fix the «Invalid default value for 'updated_at'» MySQL 5.7 failire?

I have encountered this issue while installing demo data for the Magetique design theme:

01

Remove the NO_ZERO_DATE flag from the sql-mode option, and then restart the MySQL server.