UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'puAc+8svwlwWAg05WEIvbolHaxo4ywF6elBWKOTDQig='
WHERE
key_id = '3970c2575cd4390fcf1903e37cafad70a6cef48441f9679a7fd89010b5ec0d29'
AND (
token = 'puAc+8svwlwWAg05WEIvbolHaxo4ywF6elBWKOTDQig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)