Model cache refresh failing due to timeout

I created a model based on a SQL query that is averaging 60 seconds to run.
I'd like to cache this.

I've turned on caching, and we created a schema for the cached model.
However now we're getting emails that reference the last run and say the following:

Model refresh for Heroku Production (read-only) failed

We ran into some trouble refreshing the model userlocationwithcity. You can see the error description below:

Killed mysql process id 20,478,920 due to timeout.

What's the timeout you have setup on mysql? Since form the error it seems that mysql is simply killing the query due to timeout