UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5zSPN1Z1v+o82EXcBwS3Ns+9BvLPTGibYFPT3p+Q5Os='
WHERE
key_id = 'e065b7ac085847baea5a42cf37ffe618ee7122678eb3aa1f8ef2d39857370fd1'
AND (
token = '5zSPN1Z1v+o82EXcBwS3Ns+9BvLPTGibYFPT3p+Q5Os='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)