Query sys_audit and syslog_transaction table

Hello everyone, 

I am trying to query the sys_audit and syslog_transaction table to get all the records. I am well aware of the massive size of these tables and the performance overhead of querying them. Nevertheless, ignoring the overehead, How would one go about achieving this? My aim is to query these tables to get all the records, not all at once but periodically works. I have tried to paginate using the sysparm_limit and sysparm_offset parameters but that also returns max execution time reached error. The other requirement is to achieve this using the REST API without using javascript or python.

Help would be highly appreciated. Thank you.