UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'TGRf6gvBTPe4tIPMu0Mm0n55swyeedMlbNt4Ko62NkU=' 
WHERE 
  key_id = '3ef423f6b1a754beac5c0a3d4ebe85d5e7ea0c2b7f82f3282a735350d2ccab2b' 
  AND (
    token = 'TGRf6gvBTPe4tIPMu0Mm0n55swyeedMlbNt4Ko62NkU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00012