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