What sequence of row locks takes place in the case of a SELECT ... INNER JOIN ... FOR UPDATE and how to avoid deadlock?

-- Memory temporary table TQueue CREATE TEMPORARY TABLE IF NOT EXISTS TQueue ( ID bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, QUEUE_STATUS enum ('ADDED', 'PROCESSED', 'SUCCESS', 'ERROR') NOT NULL DEFAULT 'ADDED' QUEUE_TIMEOUT datetime NOT NULL, ACTION enum ('INSERT', 'DELETE', 'UPDATE') NOT NULL, REPORT_ID tinyint(4) UNSIGNED NOT NULL, LOGIN int(11) NOT NULL, `GROUP` char(16) NOT NULL, ENABLE int(11) NOT NULL, ENABLE_CHANGE_PASS int(11) NOT NULL, ENABLE_READONLY int(11) NOT NULL, ENABLE_OTP int(11) NOT NULL, PASSWORD_PHONE char(32) NOT NULL, NAME char(128) NOT NULL, COUNTRY char(32) NOT NULL, CITY char(32) NOT NULL, STATE char(32) NOT NULL, ZIPCODE char(16) NOT NULL, ADDRESS char(128) NOT NULL, LEAD_SOURCE char(32) NOT NULL, PHONE char(32) NOT NULL, EMAIL char(48) NOT NULL, COMMENT char(64) NOT NULL, ID_DOCUMENT char(32) NOT NULL, STATUS char(16) NOT NULL, REGDATE datetime NOT NULL, LASTDATE datetime NOT NULL, LEVERAGE int(11) NOT NULL, AGENT_ACCOUNT int(11) NOT NULL, TIMESTAMP int(11) NOT NULL, BALANCE double NOT NULL, PREVMONTHBALANCE double NOT NULL, PREVBALANCE double NOT NULL, CREDIT double NOT NULL, INTERESTRATE double NOT NULL, TAXES double NOT NULL, SEND_REPORTS int(11) NOT NULL, MQID int(10) UNSIGNED NOT NULL, USER_COLOR int(11) NOT NULL, EQUITY double NOT NULL, MARGIN double NOT NULL, MARGIN_LEVEL double NOT NULL, MARGIN_FREE double NOT NULL, CURRENCY char(16) NOT NULL, API_DATA blob DEFAULT NULL, MODIFY_TIME datetime NOT NULL, PRIMARY KEY (ID), IDX_JOIN INDEX USING BTREE (LOGIN, REPORT_ID) ) ENGINE = MEMORY; CREATE TABLE `MT4_USERS` ( ID bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, REPORT_ID tinyint(4) UNSIGNED NOT NULL, LOGIN int(11) NOT NULL, `GROUP` char(16) NOT NULL, ENABLE int(11) NOT NULL, ENABLE_CHANGE_PASS int(11) NOT NULL, ENABLE_READONLY int(11) NOT NULL, ENABLE_OTP int(11) NOT NULL, PASSWORD_PHONE char(32) NOT NULL, NAME char(128) NOT NULL, COUNTRY char(32) NOT NULL, CITY char(32) NOT NULL, STATE char(32) NOT NULL, ZIPCODE char(16) NOT NULL, ADDRESS char(128) NOT NULL, LEAD_SOURCE char(32) NOT NULL, PHONE char(32) NOT NULL, EMAIL char(48) NOT NULL, COMMENT char(64) NOT NULL, ID_DOCUMENT char(32) NOT NULL, STATUS char(16) NOT NULL, REGDATE datetime NOT NULL, LASTDATE datetime NOT NULL, LEVERAGE int(11) NOT NULL, AGENT_ACCOUNT int(11) NOT NULL, TIMESTAMP int(11) NOT NULL, BALANCE double NOT NULL, PREVMONTHBALANCE double NOT NULL, PREVBALANCE double NOT NULL, CREDIT double NOT NULL, INTERESTRATE double NOT NULL, TAXES double NOT NULL, SEND_REPORTS int(11) NOT NULL, MQID int(10) UNSIGNED NOT NULL, USER_COLOR int(11) NOT NULL, EQUITY double NOT NULL, MARGIN double NOT NULL, MARGIN_LEVEL double NOT NULL, MARGIN_FREE double NOT NULL, CURRENCY char(16) NOT NULL, API_DATA blob DEFAULT NULL, MODIFY_TIME datetime NOT NULL, PRIMARY KEY (ID), UNIQUE KEY IDX_LOGIN_REPORT_ID (`LOGIN`,`REPORT_ID`) ) ENGINE=InnoDB ROW_FORMAT=COMPRESSED