OPW Fibrelite currency issue while adding the products to cart

Problem Statement:- User is not able to add product using quick order functionality in OPW Fibrelite.
Root Cause :- User has already active basket with USD currency in ISH Database and trying to add product with EUR currency view quick order functionality.
Solution:-
Short term fix:- Created ISH dev ops ticket to invalidate the user basket using update query.

NOTE:- Please change the mail id according to the user in the query

Query to Identify the basket of a user:-

select * from basket where status=0 and userid in (select basicprofileid from basiccredentials where login='[e-mail]' and domainid in (select domainid from domaininformation where domainname like 'OPWEMEA-FIB%'))

Query to invalidate the basket of a user

update basket set status=4 where status=0 and userid in (select basicprofileid from basiccredentials where login='[e-mail]' and domainid in (select domainid from domaininformation where domainname like 'OPWEMEA-FIB%'))