Just found solution accidentally, have no idea why it is working like below:

LOWER(e.description) LIKE LOWER(CONCAT('%',:text,'%')) OR :text IS NULL)