UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r+w/DiS39Q9DdfoRSD+tZdgzT1V7+UV854Uh4tiy9Ww='
WHERE
key_id = '21713c8b95be1008e167ad07e01956f2685c470c69b00a6ee1c0b075461af450'
AND (
token = 'r+w/DiS39Q9DdfoRSD+tZdgzT1V7+UV854Uh4tiy9Ww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)