Where are you storing the zap request note kind=9734? Do you use cln or lnd?
Discussion
I either store them in the object storage or might keep them in cache only as you only need to remember them from payment request to actual payment settlement. The receipt (like any LNURL stuff) lives only in the realm of the Bot / LN wallet and doesn't touch the LN node.