UPDATE 
  q_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7dYwhpvvb08L1E7pLFcrT83+66E5yjbuM7ykGg+/c/8=' 
WHERE 
  key_id = 'b6504476f75c72bf4cba6964683a8e2337d6c6bdc94afda7f61910383119e6d3' 
  AND (
    token = '7dYwhpvvb08L1E7pLFcrT83+66E5yjbuM7ykGg+/c/8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028