Sandbox

SELECT lang.name, lang.value FROM cscart_language_values lang WHERE lang.lang_code = 'tr' AND lang.name IN ('create_account', 'create_account')

Query is invalid

Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lang	range	PRIMARY	PRIMARY	392		1	Using index condition