UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sd6rzbe1TAh34aaqa+V3nVyqwYD5ti50jyrLZG6myYU='
WHERE
key_id = 'b541092d3bf101c76afdb7c2c4b42b6d4eea512009c869861121f465810213a3'
AND (
token = 'sd6rzbe1TAh34aaqa+V3nVyqwYD5ti50jyrLZG6myYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)