UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n/jmrdEoEEZfVGW7v4DgLvzY57d98qpEyOmGmv2T4WM='
WHERE
key_id = '011b9b4d6dbc55bf5e4db2c25ba26aab5252c1136c13573c50d1579adf7062d1'
AND (
token = 'n/jmrdEoEEZfVGW7v4DgLvzY57d98qpEyOmGmv2T4WM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)