Split the rollback transaction by date

We are seeing mysql locks with large rollbacks, splitting by date
should reduce the chances of this happening.

We should be covered by the redis-lock preventing other processes
using the db while this happens