UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bjvjTkTOFWabK+0EZwi9aqiNyBWmasnY3M8HA4DJirs='
WHERE
key_id = '0bc21f20974417cef40b32a12b1646418f13dde87061ed2069fb12b1afb0276d'
AND (
token = 'bjvjTkTOFWabK+0EZwi9aqiNyBWmasnY3M8HA4DJirs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)