MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE appconfig (
  `id` INTEGER,
  `appid` VARCHAR(4),
  `keyValue` VARCHAR(8),
  `dataValue` VARCHAR(10)
);

INSERT INTO appconfig
  (`id`, `appid`, `keyValue`, `dataValue`)
VALUES
  ('1', 'app1', 'hitcount', '3'),
  ('2', 'app1', 'lasthit', '2022-03-23'),
    ('3', 'app2', 'hitcount', '3'),
  ('4', 'app2', 'lasthit', '2022-03-22');
UPDATE appconfig a1
INNER JOIN (SELECT `appid` FROM appconfig WHERe DATE(`dataValue`) < current_date() 
AND `keyValue` = 'lasthit' ) a
ON a.`appid` = a1.`appid`
SET 
    dataValue = 0
WHERE
 keyValue = 'hitcount'
SELECT * FROM appconfig


id
appid
keyValue
dataValue


1
app1
hitcount
3

2
app1
lasthit
2022-03-23

3
app2
hitcount
0

4
app2
lasthit
2022-03-22

id	appid	keyValue	dataValue
1	app1	hitcount	3
2	app1	lasthit	2022-03-23
3	app2	hitcount	0
4	app2	lasthit	2022-03-22