how can we use simple rls filter in guest token for embedded dashboard when "GLOBAL_ASYNC_QUERIES": True?

[sreejithac43]

Please help in figuring out whether RLS bug when feature flag
"GLOBAL_ASYNC_QUERIES": True
is still solved for the superset 4.1 version
Case:
I was using
{
"user": {
"username": "guest",
"first_name": "guest",
"last_name": "guest"
},
"resources": [
{
"type": "dashboard",
"id": "d035c4d2-3e2c-4e3f-b45e-20ebb8b366e8"
}
],
"rls_rules": [
{
"clause": ""STATEID" = 3"
}
],
"iat": 1734112254.027939,
"exp": 1734112554.027939,
"aud": "http://0.0.0.0:8080/",
"type": "guest"
}

payload similar to this to create guest token for embedded dashboard and it was working fine till I enabled GLOBAL_ASYNC_QUERIES. it seems to be a known issue that GLOBAL_ASYNC_QUERIES and rls filtering cause a bug but it seems it was solved in a Version 3.1 and closed according to discussions like
#18924
#24171

please help me to use RLS filtering along GLOBAL_ASYNC_QUERIES
Note: I have celery worker and Redis cache set up in a production deployment