UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y90BjR2ThBEzzjwOD4JDN1aHM2A8GN90Yces/Shon6w='
WHERE
key_id = 'a648a46ec5300f9cf071018b0763cf42310fa650611241564cbef9e465643059'
AND (
token = 'y90BjR2ThBEzzjwOD4JDN1aHM2A8GN90Yces/Shon6w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)