How to set timeout on a query?

[SuperCuber]

My code is something like this:

(def-db-fns ...)
(declare my-query my-query2)

(with-open [connection (next.jdbc/get-connection conn-pool)]
  (my-query connection params)
  (my-query2 connection params))

I'd like to add a timeout to this operation, either to each query or to the whole batch. How to do that?