请大佬帮我看看，这个sql有什么问题

Question

UPDATE t_summary 
SET benefit = benefit + 1,agency = agency + 1,SHARE = SHARE + 1,counteract = counteract + 1 
#SELECT * from t_summary
WHERE
	cre_month =(
	date_format( DATE_SUB( curdate(), INTERVAL 1 DAY ), '%Y%m' )) 
	AND pos_type IS NULL 
	AND user_id IN (
	SELECT
		t.id 
	FROM
		t_user t
		LEFT JOIN t_benefit tt ON tt.user_id = t.id 
	WHERE
		t.today = 1 
		AND tt.pos_type = '01' 
		AND tt.cre_date =(
		date_format( DATE_SUB( curdate(), INTERVAL 1 DAY ), '%Y%m%d' )) 
		AND tt.money = '-1' 
	AND tt.state_type = 0 
	)

这段sql执行注释内的查询操作可以正常运行，但是执行更新操作就一直报错：

1205 - Lock wait timeout exceeded; try restarting transaction

 

Answer 1

#SELECT * from t_summary  这个放到where条件下面