UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'krDuu7o3MZOmUktqX3V2Hym0GERTxadswM01mBH3dtY='
WHERE
key_id = 'f301637d297c678b10bbf6152baf7603ac25e3182c0a47bcce3dfcb1ab4d2700'
AND (
token = 'krDuu7o3MZOmUktqX3V2Hym0GERTxadswM01mBH3dtY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)