Hi
I'm afraid that no-one here can look into the issue for you. You are not talking to Apple here - this is a user-based technical support community.
If you cancel a payment or if the payment expires due to the recipient not accepting it, then the funds will be returned automatically to your Apple Pay Cash Card balance or to your payment card account, depending on how the payment was originally funded.
Whilst Apple has not specified how long this will take, if you remain concerned after allowing a reasonable period of time, then I suggest that you contact Apple Support for assistance via the link at the bottom of this support article:
If you need help sending or receiving money in Messages with Apple Pay - Apple Support