UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '9X5JN4V4Z7x8hULoP+3wJXivszyVsRWuTrEy/Z9T0TA=' 
WHERE 
  key_id = 'd1dc2fb46dc82412ae07ae3396c991e86123e6cfcce00e39d750bc2e73be2c72' 
  AND (
    token = '9X5JN4V4Z7x8hULoP+3wJXivszyVsRWuTrEy/Z9T0TA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00012