Do you run also any security plugin?

Is Database caching enabled in wp-rocket?

Here, they are talking on what i first suggested. Caching ....

https://wordpress.org/support/topic/deadlock-error-on-actionscheduler-actions-table/

Make a NEW topic, mark it PRIVATE and post your site url, so the support staff can maybe help more on this.