Use CONCAT_WS.

WHERE CONCAT_WS(' ', firstName, lastName) LIKE CONCAT('%', 'alex', '%')

It concatenates all NOT NULL arguments from the 2nd to the end, with the first one as separator, and returns NULL only if all of them are NULL.